Visualize Key Insights/Key Takeaways 24
********************************************************************

Visual Key Insights / Key Takeaways
********************************************************************


1st go back and review the Visualize Key Insights section earlier in the documentation.  If you used the Project Checklist while working through your project, you probably already have most of this complete.  Now is the time to make it look good and present.

Two Sections:

Key Insights

                       KPI

                       Good or Bad

                       Responsible Dim

                       What is good/bad

                       Where is occurred

                       When it occurred

                       The Extent of the good/bad

                       How I know it is good/bad

Proof

                       a.  Create a  GIF showing filters on for "Extent" and moving to "How I know" selections.  You can also do it reverse by showing "How I know" selection 1st.  Either way the gif will back and forth from both set of selection groups so the audience can see the insight in your gif

                       b. Screenshot of your nicely formatted SQL code with the results.  The numbers used in "Extent" should be highlighted in the screenshot.



Words of Wisdom

More often than not you will want to  use Date Comparisons such as

These comparisons are very good when  showing movement or which direction something is headed.  When you try to explain these in your insight, below is a guide of how to explain so people can understand

March 2020 YoY = 60%

March 2020 MoM = -10%

Sometimes it can be tricky revealing this information in a way where people can understand . Hopefully the above examples help.
















DW Example